Split string that has new line and a lot of spaces in it

Help
,
#1

i want to split the following string:
Client ID: RU90268
Client Name: Veda Blaylock
Client Country: Germany

and get value RU90268, Veda Blaylock and Germany

#2

there is a new line and it is followed by 19 spaces

#3

@Aishwarya_Bhargava - Is the new line in between each line ? could you please clarify?

#4

it is in between all the three lines, its occurring twice in the whole string

#5

You can use Regex or split method to get the desired output

#6

i am not good at writing regex expression, so can you help me with that

i tried using split but its not working
Split(ClientDetails," “)(1).Split(”:"c)(1).Trim
i used this

#7

First split using Environment.newline and then Split using “:”

#8

it is showing index out of bound

#9

@Aishwarya_Bhargava - This post will help you…

If you are still not able to solve using string.Split method …please let me know, I will provide 3 Regex patterns…

2 Likes
#10

i was able to get client id but nothing else

can you please help

#11

Hi @Aishwarya_Bhargava,
Can you please try this:

(?<=\ \w+:\ )(\w*\ \w*)

Thanks

#12

that is working with the client name

#13

Hi @Aishwarya_Bhargava,
Can you please try this:

(?<=\s\w+:\s)(\w*\s*\w*$)

Check with the below mentioned link for further clarification:

Thank you

#14

it worked for all of them after making some adjustments

thankyou :slight_smile:

1 Like
#15

Hi @Aishwarya_Bhargava,

Happy to help!
Please try with this also:

image

1 Like
#16

okay will do

1 Like
#17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.