Questions tagged [split]
The split tag has no usage guidance.
42
questions
0
votes
1
answer
30
views
AMPscript Help for Splitting Field
I'm new to Marketing Cloud and not fluent with AMPscript. Can someone please help with my script to split a field and only display the venue name on the back end?
I'm getting the error message:
A ...
0
votes
2
answers
75
views
String split on newline creates blank strings for every newline
I have a split on a newline which works fine, but it seems to create a blank value for every time it does a split, so 'MyText' contains the following values, separated by a newline:
Blue
Green
Yellow
...
- 1,509
-1
votes
1
answer
53
views
How "String Split" method works?
How "String Split" method works for the below snippet?
String emailAddress = 'test@test.com,test1@test.com,';
There is no value after the second comma. Even it will not throw any errors but ...
0
votes
1
answer
42
views
Using split function
String tem = '1SD,"MASK, ALEXIS",AETNA,W265925029,1119707362,7/1/2022,3/28/2022,"$4,500.00 ",Detox,"$1,126.50 ",25%';
here i wanna iterate over each an every element by ...
0
votes
2
answers
207
views
Equally Split a DE by segment
I have a DE with about 4m records. I am looking to do a 50/50 split for testing but by a specific column. So within that DE, every record has a "Segment". So there might be 500k customers, ...
- 23
-1
votes
1
answer
496
views
Split | character in string
Is there a way I can split | character in a string?
I'm trying with
myString.split('|')
but it's not working.
Regards,
- 835
0
votes
2
answers
938
views
Random Data Extensions: Need to split larger audience into 20 different DEs
As part of IP warming - I need to segment a Data Extension of 5 million users into roughly 20 segments, some of different values as we slowly warm the IP across the fist send through the user base. ...
- 1
0
votes
1
answer
794
views
How to enable split view for a LWC or Aura CustomTab? [duplicate]
I'd like to enable split view support for my CustomTab but I don't find any information regarding how to do that. Salesforce seems to have been able to do that internally with High Velocity Sales but ...
- 11
1
vote
5
answers
4k
views
Cannot read property 'split' of undefined - in LWC js
I have the following LWC, when I try to add on my lightning record page got some error like, cannot read property of split.
js:
import { LightningElement, api, track } from 'lwc';
export default ...
- 43
0
votes
1
answer
237
views
Passing Flow variables into apex
I have passed a string in exactly this format with a ',' delimiter (a014K000001W1wqQAC,000410001006672,500,34567) from a flow to an invocable APEX method.
public class obuTopUpTrailhead {
@...
- 17
0
votes
1
answer
328
views
SFMC API Triggered Journey: Random Split
If we add the random split in 2 paths in an API triggered journey in Salesforce Marketing Cloud, where contacts come one at a time after they sign up on a website, will this ensure that equal number ...
- 1
0
votes
1
answer
2k
views
SSJS Split String
How to use split function in SSJS to split String?
In my case, I have given the String and , the way I want to split is as follows :
My String : I want 2 splits
dfc_1 : dfc_ and 1
dfc_45932 : dfc_ ...
- 33
0
votes
2
answers
1k
views
Using SQL to split a data extension into 4 mutually exclusive groups
I have a data extension that I need to split into 4 mutually exclusive data extensions. I would like to avoid using the Random data extension feature in Salesforce since I would like to refresh these ...
- 185
0
votes
1
answer
993
views
Exists in whole word in Decisions Splits in Journey Builder doesn't work
I use often the operator "Exists in whole word" in the email studio to filter on a list of attributes. To do that I separate my values with a coma.
I tried within a journey but it doesn't work...
Do ...
- 1
1
vote
1
answer
311
views
Is it possible to override String.split function in Salesforce Apex?
I want to override split function of String class with one more parameter.
Is it possible?
String s = 'aKey:aValue::bKey:bValue::cKey:cValue';
Map<String, String> mapS = s.split(':', 0, '::');
...
- 21
-3
votes
1
answer
300
views
How to write a method to remove non alphanumerics in a string and display it in a list [duplicate]
method to remove non alphanumerics in a string and display it in a list.
public static list<string> s(){
String stg = 'ABC,DEF,GHI,JKL';
List<String> lst = stg.split(',');
...
- 7
0
votes
1
answer
713
views
How to separate The Day, Month and Year attributes using SQL _Open query in salesforce marketing cloud?
I have creating TestDE Data extension using these attributes like SubscriberKey, AccountID, EventDate, Date, Month, Year attributes. And Created with same attributes using Target Data extension. Now ...
- 217
2
votes
1
answer
752
views
Split a row with data separated by ","
I need to split a row from a DE. The row contents 4 strings, and I want to see the content in a table. Right now I have some code; but doesn't work:
Script
%%[
VAR @Productos<br/>
SET @...
0
votes
2
answers
507
views
Split text data by number [closed]
I need to split 10 digit number using apex. This is my input addresses
IDOC error for partner 0001204140 team
My output like below:
0001204140
- 317
2
votes
1
answer
4k
views
How to reproduce a unique list based on a field value
Lets say I have a list of a sObject with several records which have a some same values in a field/column. What is the fastest way to reproduce a new list with only unique values for this list.
Record ...
- 2,284
0
votes
1
answer
136
views
Trigger to remove text before and after [closed]
I want to split text out of c.Description to populate a custom field Response_Name__c
c.Description is
"Sent on : 1/3/2018 9:24:00 PM
By User: Julie Trigger
Comment"
I want Response_Name__c to ...
0
votes
1
answer
826
views
Field history tracking for opportunity split object
I have create a custom object to track field changes on opportunity split object and written trigger on opportunity split object. But I am not getting expected result for inserting new records in ...
1
vote
2
answers
8k
views
How To Split String by space and store each character or substring in array
How To Split String by space and store each character or substring in array
I have: String - '(1 OR 2) AND 3'
I need in this way:
String [] filterLogicSplittedbySpace=new String[]{'(', '1', 'OR', ...
- 61
0
votes
0
answers
3k
views
Enable Split View In Lightning
My lightning org does not have Split View enabled.
I am trying to find where it can be enabled from but with no success.
What I observed is some of my Apps has it enabled while the others don't.
From ...
- 59
0
votes
2
answers
5k
views
String Split method
Apex String split() results an empty list item even there is no value.
For example,
String test = '';
list<string> test1 = test.split(',');
System.debug(test1.size()); // Result = 1
so I ...
- 2,375
1
vote
1
answer
811
views
Random data extensions: How to create more than 12
I need to split a data extension into 80 random data extensions, but have just realized that creating a random data extension from a selected data extension only allows up to 12 splits.
If any of you ...
- 531
1
vote
1
answer
802
views
Marketing Cloud - Journey splitted according to email opening
how is it possible to split the journey into two branches, according to the email opening?
This is the desired steps:
Send email --> Check if the email was opened --> if yes, continue in the journey ...
- 13
0
votes
1
answer
1k
views
Parse HTTP Response
How to parse the HTTP Response if response string is in name value pair.
RESULT=0&PNREF=EFHP0D426A53&RESPMSG=APPROVED&AUTHCODE=25TEST&AVSADDR=Y&AVSZIP=N&CVV2MATCH=Y
- 13.5k
0
votes
2
answers
891
views
Selectlist options change not reflecting in apex class
I am facing an issue where a select list value default selected getting passed fine to controller during compile and page load. But on change simply it's even not coming on debug statement.
Apexpage
&...
- 2,930
2
votes
1
answer
118
views
Cannot get aggregate result (or anything good) with SOQL on multiSelct picklist
I have a working aggregate result class with a wrapper. Have made a couple of data sets pulled from cases and campaigns to get aggregate results of participants of both by date and other fields. ...
- 21
0
votes
1
answer
68
views
Attempt to de-reference a null object - Error in sorting list
I am getting subject line - error while I try to execute below apex code snippet
Apex Code Snippet
for(Integer index = 0; index < surveyInstanceList.size(); index++) {
Survey_Question_vod__c ...
- 2,930
0
votes
2
answers
57
views
Question on split function on a text field
I need your help in splitting the following text.
Here is the text field : - 'Lead id of this field ref:_x12rftf001265qr.dt50:ref'
How I can split this text to get only this text 'ref:...
- 61
2
votes
1
answer
291
views
split before GROUP BY soql
I have a field which has the values in the format [5 digits-3 digits]
12345-123
34646-345
12345-133
I want to Group BY this field with the just the 5 digit number only (not the complete field). How ...
- 4,019
0
votes
1
answer
2k
views
Refresh/update data extension random splits
I have made a 5 way split based on a data extension, but I can't find anywhere I can refresh this split after its made, like you can with Groups for Lists.
Anyone know if this is possible to do?
- 493
1
vote
1
answer
3k
views
Split by semicolon of a string not working
In below code semicolon separation not working for string with email addresses. Can someone help please?
Apex code
List<ABV_Form_Request_abv__c> Useremails= ABV_Form_Request_abv__c.getAll()....
- 2,930
2
votes
1
answer
6k
views
apex string split
Unable to split string by multiple characters.
String myString = 'abc$$$xyz';
string[] myArray = myString.Split('$$$');
System.Debug(myArray.Size());
I get result for myArray.Size = 1 and when ...
- 1,137
3
votes
2
answers
3k
views
How to automatically create Opportunity Splits through a trigger?
I am looking to automate the creation of Opportunity Splits on each opportunity as we cannot trust Sales Reps to add the Opportunity Team and Opportunity Splits accurately. So I decided to automate ...
-1
votes
1
answer
2k
views
How can i split the address
I need to split the address using script. This is my input addresses
1 Avenue Descartes 92350 Le Plessis-Robinson FRANCE
My output like below:
1
Avenue Descartes
92350
Le Plessis-Robinson
FRANCE
- 141
0
votes
2
answers
4k
views
How to place the google map address in account object?
I have created visual force pages for Google map using auto complete functionality. It's working fine in visual force page only but I need to place the account object in billing and shipping address. ...
- 141
0
votes
1
answer
113
views
Split method truncating result and appending '...' in the end
String s = 'a b c d e f g h i j k l m';
System.debug(s.split(''));
above code returns (, a, , b, , c, , d, , e, ...)
am I missing something?
Please help
- 39
3
votes
0
answers
45
views
Org-wide Addresses after split
What will happen with the Organization-wide Addresses after org split? Will they remain active, or become not verified or something else?
I've been searching for the answer here but with no success.
- 2,346
0
votes
2
answers
169
views
Upcoming Salesforce server split, know the new server in advance?
Salesforce has notified us that our NA4 server will be splitting on March 21, 2015. Is there any way to know in advance what Salesforce server our production instance will live on after the split?
- 103