10-25-2022 04:28 PM - last edited on 05-02-2023 10:37 AM by JackLacava
My source file has a column that contains both, account name and account description. The account names are either 4, 6, or 7 characters and there is a dash (-) in between the name and description (see example below). I'm trying to extract the account name but I have not had any luck with the In String function. Any suggestions?
Account Name and description:
123456 - Cash
2345 - Accounts Payable
3456789 - API
Function in Excel: =LEFT(A1,FIND("-",A1)-2))
Solved! Go to Solution.
10-26-2022 01:32 PM
Dim fields as List(Of String) = StringHelper.SplitString(args.Value, "-", StageConstants.ParserDefaults.DefaultQuoteCharacter)
Return fields(0).Trim
10-26-2022 01:32 PM
Dim fields as List(Of String) = StringHelper.SplitString(args.Value, "-", StageConstants.ParserDefaults.DefaultQuoteCharacter)
Return fields(0).Trim