Header Split

[Yogita_Gaikwad]

I want to Split Text file header then how i do it

[Gokul001 (Gokul Balaji)]

Hi @Yogita_Gaikwad

Can you share the Sample Input and expected output

[Marius_Puscasu]

Hello @Yogita_Gaikwad ,

Please check this megapost:

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

Hope it helps!
Best regards,
Marius

[Yogita_Gaikwad]

This is my code

Text file header come like this i want split like

InvoiceNumber
BillingDate
ShipDateSalesOfficeNumber
.
.
.

[Gokul001 (Gokul Balaji)]

Can you share the Text file here @Yogita_Gaikwad

[Yogita_Gaikwad]

sorry i can’t share

[Gokul001 (Gokul Balaji)]

@Yogita_Gaikwad

Share this only @Yogita_Gaikwad

[prithivi_raj_shanmugam]

@Yogita_Gaikwad In that text file, do you have only headers? If you have only headers, I could see space in between each header you can use “String.Split(” “C)” and have the values as a array

[Yogita_Gaikwad]

sam.txt (345 Bytes)

[Gokul001 (Gokul Balaji)]

Hi @Yogita_Gaikwad

How about this expression

yourString.Split(Environment.NewLine.ToCharArray).AsEnumerable().Where(Function(x) Not String.IsNullOrEmpty(x.ToString.Trim)).ToArray()

Or

yourString.Split(Environment.NewLine.ToArray, StringSplitOptions.RemoveEmptyEntries)

Regards
Gokul

[Yogita_Gaikwad]

sam.txt (343 Bytes)
this is my text file can u split this like
InvoiceNumber
BillingDate
ShipDate
.
.

[kennbalobalo (Kenneth Balobalo)]

hi @Yogita_Gaikwad,

You can create a List(Of String) type variable and then initialize it. Then after that you can split the string by using “yourString.Split(vbTab.ToCharArray).ToList”

I also attached my code here for your reference
StringSplit.zip (2.4 KB)

If this does helped you, kindly mark it as Solved to help others as well. Thanks.

Kind regards,
Kenneth