How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hello, You can use:

A) Split by char
Where:
Variable:
text = eg. Generic Value
new_text = String (Array of strings)

Input:
text = JOHN SMITH\r\n2 September 2019\r\nPowered by TCPDF (www.tcpdf.org)

Logic:

new_text = Split(text," "c)
  1. Exampe
    Write Line = new_text(0) + " " + Split(new_text(1),"\r\n2")(0)

Output: JOHN SMITH

  1. Example

    Write Line = new_text(0) + " " + Split(new_text(1),"\r\n2")(0) + " " + new_text(2) + " " + Split(new_text(3),"\r\n")(0)

Output: JOHN SMITH September 2019


B) Split by Split in String

  1. Example
    To Get FirstName and Last Name You can use also:

Variable:
text = eg. Generic Value
new_text = String

Logic:

new_text = Split(text,"\r\n2")(0).ToString

Write Line: new_text

Output: JOHN SMITH

  1. Example
    Additionally to Get “Month Date”

Logic:

new_text = Split((Split(text,"\r\n2 ")(1).ToString),"\r\n")(0).ToString

Write Line: new_text

Output: September 2019

16 Likes