Conditional use of "_Excel_RangeRead"

[soft4pedia]

Hello,

I trying to copy text from a specific cell "C1" of an Excel sheet. Script successfully copy the content from excel sheet and show it in a message box but I want to use _Excel_RangeRead command on conditional basis such as I want copy whole cell just after skipping data available in brackets like i don't want to copy edition of book and want to copy rest of data behind and after those brackets for example

Value available in Cell "C1" is;

Fundamentals of Financial Management [13th Edition] by Van horne & John M Wachowicz

my requirements is like this:

Fundamentals of Financial Management by Van horne & John M Wachowicz

Please guide me how can it be possible

 

$File = _Excel_RangeRead ($oWorkbook1, Default, "C1")
ClipPut(FileRead($File))
Msgbox(0,"", $File)

 

[MuffinMan]

There's probably a very elegant RegEx way of doing that, but this works too...

$File = "Fundamentals of Financial Management [13th Edition] by Van horne & John M Wachowicz"
If StringInStr($File, "[") AND StringInStr($File, "]") Then
    $File = StringLeft($File,StringInStr($File, "[")-1) & StringRight($File,StringLen($File) - StringInStr($File, "]")-1)
EndIf
MsgBox(0,"",$File)

 

[soft4pedia]

Hello MuffinMan,

you did awesome job, but you totally missed my point I don't have values like you used basically I've values saved in an Excel file that's why I've to use _Excel_RangeRead command combination with StringRegExpReplace command to remove my desired content while copying from a desired cell.

Basically I've combination of characters to show versions of books like below

some books show differently like:

[12th edition]

[10th edition]

(13th edition)

{11th edition}

these 4 combinations are available through excel sheet from 11th to 14 edition only so please guide how can i use _Excel_RangeRead command with combination with StringRegExpReplace to fulfill my requirements...

[water]

_Excel_RangeRead returns a String. So replace

$File = "Fundamentals of Financial Management [13th Edition] by Van horne & John M Wachowicz"

with your _Excel_RangeRead statement, then add additional checks for () and {} as suggested by MuffinMan.

[soft4pedia]

Got it thanks it's working mate...

[iamtheky]

$File = "Fundamentals of Financial Management [13th Edition] by Van horne & John M Wachowicz" & @LF & _
"Fundamentals of Financial Management {14th Edition} by Van horne & John M Wachowicz" & @LF & _
"Fundamentals of Financial Management (15th Edition) by Van horne & John M Wachowicz"

msgbox(0, '' , stringregexpreplace($File , "\[.*?\]|\{.*?\}|\(.*?\)" , ""))