Member Avatar for davidao

Hi,
I am trying to find a solution for a problem..
I've got a string but I need to format it in a specific type....

#-0.6|141.443719976486|59.8780753410541|-0.6|140.736613195299|59.1709685598
#534359|59.1356132208082|-0.6|140.821466009042|59.1851106954913|
#17|-2.03|141.39422501803|59.828577866371|-2.03|140.78611066998259.2204660345
#9042|59.1851106954913|-2.03|140.821466009042|59.1851106954913|#40.82146600902.03140.786110669982|59.2204660345506|-2.03|140.786110669982|
#9042|59.1851106954913|-0.67|141.429577840862|59.7932225273117|-0.67|#140.821466009042|59.185110695491|

I am trying to end each line with "|" and move the rest of the characters to the next line....

Any help please!!

  • 2 Contributors
  • 1 Reply
  • 77 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by selvaganapathy
Member Avatar for selvaganapathy

Hi, Use Split() function to split the strings
Syntax

Split(expression, delimiter)
Ex.

dim Obj as variant
Dim sSTring as String
sString = "#-0.6 ........"
Obj = Split (sString, "|")

.....
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.