pipe delimited

Hi - I wanted to see what the best method is to find a value in a pipe-delimited string in one cell that matches a value from a list and extract that value. Example: Metric Pipe Delimited Values 3 112356|229531|229327|229533|229532 5...

Can anyone help me adjust my macro. I just need it so that any rows with Value 'Q' in Column A are skipped and not exported to the pipe seperated sheet ? Thanks. Alex Public Sub CharacterSV() Const DELIMITER As String = "|" Dim myRecord As Range Dim myField As...

Hi, I am using the below code to Generate a text File in pipe Delimited format. Sub ExportTxt() Dim UsedRows As Long Dim UsedColumns As Long Dim R As Long, C As Long '// Define a suitable file name Open "E:\Folder\" & "TD.txt" For Output As #1 With ActiveSheet...

Hello, I recently created a macro to create a pipe delimited file from a large spreadsheet. The system that processes the .txt file cannot handle 0's in any cells, but it can handle it if there are decimals (i.e. 0.0). Changing the format of the amounts in the spreadsheet to have decimals...

I have a VBA Macro that creates 50 or so CSV files (comma delimited) for our different customers. Here is a simple line I use in the Macro: ThisWorkbook.SaveAs Filename:=SaveToDirectory & “\filename nn.csv”, FileFormat:=6 Now I have one customer who wants a Pipe Delimited file. Is there a...