Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Verified Answer
Replies
7 replies
Answers
1 answer
Subscribers
10 subscribers
Views
2996 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
CSV string
Ganesh Patil
Certified Senior Developer
over 2 years ago
I have a csv string which i am getting it from blueprism through integration. i need to perform some calculation based on this value, i need to iterate this string. but i am unable to iterate its taking as only one string, i want to iterate for each line in this string.
"ABC,ABC,2,06:00:00,18:00:00,0.5,3
XYZ,XYZ,3,06:00:00,18:00:00,0.5,3"
please any suggestions on this.
Discussion posts and replies are publicly visible
Top Replies
Stefan Helzle
over 2 years ago
in reply to
Ganesh Patil
+2
verified
Certified Lead Developer
First, use split to get the lines using "char(10)" as the delimiter. Then, in a foreach, use the comma delimiter to get the values for each line.
Hrishikesh Dixit
over 2 years ago
+1
suggested
Certified Lead Developer
You can use split() function which s plits text into a list of text elements, delimited by the text specified in the separator. In your case delimiter is ",". https://docs.appian.com/suite/help/21.3…