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

2 Likes
16

okay will do

1 Like
17

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