Need support in splitting a text (Single line text field/Multi line text field- Plain Text) which has delimiters and create new items in other library/list.

Tried using sample SPD 2013 workflow, but unable to achieve exact result. (W/f enter image description here enter image description hererunning into infinite loop)

Below are the screen shots.

Eg: List A Text Field -- Name: Suresh,Rajesh,Kumar ID: 3

List/Library B

ID Name1 Name2 Name3 3 Suresh Rajesh Kumar



It is because you are not replacing the comma after replacing the substring. The WF keeps on finding the comma at 0th position and loop becomes infinite.

Modify your loop as shown below (tried and tested).

enter image description here

When you replace substring1 it should be [substring1],

  • Hi, thank you. done with changes and tried, the output at list3/ (lookup3 is running infinite loop when replaced with " _ " and with " , " splits only first word if we have 3 countries/words). Can you suggest where am i going wrong.. – Sudhir Nov 21 '19 at 6:21
  • Don't replace with underscore. Replace with a space - " ". Can you post new screenshots after replacing with space? – harshal gite Nov 21 '19 at 8:12
  • Hi Harshal,replaced with " " but the output is looping infinite.Attached all the screen shots. kindly help – Sudhir Nov 27 '19 at 5:34
  • 3rd last line where you replace - it should be replace "[substring1]," . Do not forget that "comma" is to be removed along with substring1. This was the only reason your wf was going into infinity loop. I have mentioned that. – harshal gite Nov 27 '19 at 7:15
  • Thank you Harshal, Solved and got desired results – Sudhir Nov 27 '19 at 10:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.