delimited

I am looking for a way to export data in a delimited format to text. To be clear, I have data in cells, and I need to export that to a text document to be uploaded into SAP. I can, easily enough, code a macro convert everything to text format, and add the appropriate number of spaces to the...

Hi, Please be informed that, daily i'll get minimum 20 to 30 excel workbook. Each workbook, i need to open and save as Text(Tab Delimited) Only the first sheet. Its consuming more time. So, if it is 30 files, then I need to do the same. Could someone help to automate this? Kindly let me know...

Hi, Is it possible to combine columns into one comma delimited column while keeping the formats from the cells in the columns that are to be combined then delete the columns used to combine with Example: From This: <tbody> This is not a Test This is a Test Number 100.123 90 is here...

Hi all, I've seen this topic discussed, but not sufficient to answer my question. Your help is appreciated. My goal is to export a worksheet to a new workbook, save the new workbook in a specific location with a specific file name. The next part is where I'm struggling. I then want to take...

Hi, Is it possible to save the Active Sheet data to the desktop as a text file using the Active Workbook Name and the file Extension .asc instead of .txt. I need to save it as tab delimited if the workbook name starts with the Letter A if not then save as comma delimited. Also If this can't be...

Hello, I'm trying to do what is typically done within excel using the "Convert Text to Columns" wizard (Delimited) and a "Paste Special - Transpose" function within Access. For example, within the form in access, I have several dates listed, seperated by a comma (1/3/16, 1/5/16, 1/6/16...

I have a problem with the text import wizard while importing semicolon delimited files. I get standardized files from my suppliers with product data and prices, in form of a semicolon separated text file. The problem is that sometimes excel doesn't recognize the semicolon as a delimiter, if it...

I have a lot of field data in a row that's in format: Color: Red|Title: Red Shirt|Date: 2015|Medium: cotton|Size: M| Title: Blue Dress|Date: 2014|Price: 55|Size: M| Color:Green| Type: New| Size: G| Title: Green Shirt| Here, in my data, there are many rows with new fields. There are many...

Hello All! I have a table with date in two columns (D&E) that have linked delimited data. If column D has 2 values separated by a "|" delimiter, then column E will have the same number of delimited values. <tbody> A B C D E 51 Bob PPV 15 9 61 James CHH 30|16|5 17|5|8 22 Steve PPV 55|2...

Is it possible to create a pipe delimited text file with Excel 2010, or any other version? Is so, how?

I have dozens of .txt files that I want to import into Excel so that they can be formatted, merged, referenced, etc. There are a few columns of data that are formatted in a way that imports them as dates instead of as numbers by default. I've figured out how to import them with the correct...

When I converted excel to text file via VB code, the default text file is tab delimited. Why is it so? I've done: Sub ConvertToText() ActiveWorkbook.SaveAs Filename:="E:\EXCEL\TEST.txt", FileFormat:=xlCurrentPlatformText, CreateBackup:=False End Sub Can I change the default delimition...

Hi, I would like to be able to delimit or trim data by the number of occurrences of a special character. I want to be able to extract the file path but not the file names. this is what I want it to do: \home drive\Data\Web stuff\test.xls -> \home drive\Data\Web stuff \home drive\Data\Web...

Hi, I have csv file. Normally in excel I select column "A" and can do -> text to column -> delimited >semicolon and everything will be done ok. I need to do it exaclty this same but in VBa. sub TEST Dim FileToOpen, sourceFile, outputFile As String Dim TextLine() As Integer Dim sourceWb As...

Excel 2007 Error: "The list source must be a delimited list, or a reference to a single row or column." How it currently works: User selects a two digit number from a list box located at D2. The formula below populates the listbox for E2 depending on what is selected in D2. Problem is when...

Hello, I've been searching for code that will perform the following: 1. Save the current workbook then, 2. Save the current sheet as a tab delimited file to the desktop with the same name as the current workbook then, 3. Return to .xlsx file format The file saved to the desktop can be...

I have successfully texted to columns and delimited the info I want. The next step is to sum the numbers relating to the time of day for each day of the year. But apparently, Excel will not allow me to perform that function. e.g.: <TABLE style="WIDTH: 292pt; BORDER-COLLAPSE: collapse"...

would someone please direct me in the right path - i need to accept input like below and always output to 2 columns. thanks you in advance. <table width="259" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64"> <col...

Sorry this is a compound problem but I am not sure how to solve each step with a method producing an output compatible with input types for the next piece. I need to parse comma delimited numbers (stored as text) in cells like those in col C below. I then need to look up each of the parsed...

vba newbie cant figure out where to start The imported file txt is created by copying and pasting into a notepad. The text file ends up being tab delimited. Each row should have 10 delimiters but will only have 9 in some cases because a piece of data is missing. Looking on how to create...