Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data on third line in a cell
Hi - and thanks for reading this!
I have a csv which I need to run a few format routines on to enable me to use it. The first column contains data that is wrapped into 4 lines - using carriage returns (?). I need to extract just the third line of text. I'm guessing that there is a way of determining where the end of each line is - but I don't know how! Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data on third line in a cell
Hi
The carriage returns will be represented by Char(10) Substituting the third one with a circumflex "^" and then finding that, will allow the extraction of the 4th line. =MID(A1,FIND("^",SUBSTITUTE(A1,CHAR(10),"^",3))+1, 255) -- Regards Roger Govier "maccboy" wrote in message ... Hi - and thanks for reading this! I have a csv which I need to run a few format routines on to enable me to use it. The first column contains data that is wrapped into 4 lines - using carriage returns (?). I need to extract just the third line of text. I'm guessing that there is a way of determining where the end of each line is - but I don't know how! Thanks! __________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data on third line in a cell
On Oct 21, 6:48*pm, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote: Hi The carriage returns will be represented by Char(10) Substituting the third one with a circumflex "^" and then finding that, will allow the extraction of the 4th line. =MID(A1,FIND("^",SUBSTITUTE(A1,CHAR(10),"^",3))+1, 255) -- Regards Roger Govier "maccboy" wrote in message ... Hi - and thanks for reading this! I have a csv which I need to run a few format routines on to enable me to use it. The first column contains data that is wrapped into 4 lines - using carriage returns (?). I need to extract just the third line of text. I'm guessing that there is a way of determining where the end of each line is *- but I don't know how! Thanks! __________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________ The message was checked by ESET Smart Security. http://www.eset.com Thanks Roger! That has sorted that bit of the problem. I'm now working on extracting the data after the second ^ and before the third ^ (if there is one!) Cheers. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data on third line in a cell
extracting data is always a time consuming process, for extracting
data from documents, the web, websites, or data files, i found http://www.extractingdata.com to be really useful, they build quick custom web scraping and data extracting programs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting data from a cell | Excel Worksheet Functions | |||
Extracting data from a cell | Excel Worksheet Functions | |||
Extracting data from a cell | Excel Discussion (Misc queries) | |||
Extracting data from a cell - please help | Excel Discussion (Misc queries) | |||
extracting data from a cell | Excel Worksheet Functions |