P postasat Active Member Licensed User Longtime User Feb 25, 2018 #1 Hi, I have a text file in which I use a special separator *!* between the data (can be different but not simple as comma). example of input message: phone number*!*name*!*surname*!*weight*!*height*!* 1234567890*!*bob*!*gellish*!*70*!*170*!* How can I extract all data from text between *!* ? (every data I must extract have not a fixed lenght) example: a = 1234567890 b = bob c = gellish d = 70 e = 170 Thank you.
Hi, I have a text file in which I use a special separator *!* between the data (can be different but not simple as comma). example of input message: phone number*!*name*!*surname*!*weight*!*height*!* 1234567890*!*bob*!*gellish*!*70*!*170*!* How can I extract all data from text between *!* ? (every data I must extract have not a fixed lenght) example: a = 1234567890 b = bob c = gellish d = 70 e = 170 Thank you.
DonManfred Expert Licensed User Longtime User Feb 25, 2018 #2 Read the file and use regex to split the lines into values Upvote 0
LucaMs Expert Licensed User Longtime User Feb 25, 2018 #3 Dim Words() As String Words = Regex.Split("!", YourString) Upvote 0
DonManfred Expert Licensed User Longtime User Feb 25, 2018 #4 Please use [CODE]code here...[/CODE] tags when posting code. Upvote 0
LucaMs Expert Licensed User Longtime User Feb 25, 2018 #5 DonManfred said: Please use [CODE]code here...[/CODE] tags when posting code. Click to expand... Do you think I don't know it? They are only two lines! (4 with tags ) Upvote 0
DonManfred said: Please use [CODE]code here...[/CODE] tags when posting code. Click to expand... Do you think I don't know it? They are only two lines! (4 with tags )