Extract only certain text which are needed

Calli · Oct-08-2022, 09:02 AM

Say for instance I want to extract some words which are required how should I go about doing it with Regular expression or without Regular expression

Data Sample

{"_index":"testdataset","_type":"_doc","_id":"11234567891098646","_score":1,"_source":{"_class":"net.local.host.ca","orderNo":"16536668566434698646","orderDt":"20220527","source":0,"mchntId":"0000000002","mchntOrderNo":"01a3f2b53d16290f41f","appid":"0000000003","payChannelId":"payid","amount":300,"clientIp":"192.168.0.1","currency":"0","subject":"","body":"","cpChannel":"google_upi","timeExpire":1653678578000,"description":"","created":1653657857000,"timePaid":1653657876000,"bankType":"","paySt":2,"refundSt":0,"refundedAmt":0,"checkSt":0,"fee":21,"chnlFee":9,"settleSt":1,"rutId":"0000000098","bankRspDesc":"","bankTransactionId":"20220527212419602959728091384475","credential":"214721678116","notifyUrl":"https://localhost/test/site","pageNotifyUrl":"https://localhost/test/site","notifyCnt":0,"notifySt":0,"openId":"","extra":"","countryId":"Brazil","areaId":"","regionId":"brazil","cityId":"toto","countyId":"","modified":1124657876000,"channlInfoId":"b0768be2248a4aee94ac747c2ab0000","email":"[email protected]","mobile":"100000012457","accountOwner":"Tom Hank","merchantParam":"game","transTp":0,"payAccount":"","payType":"","bankCode":"","settleBatchNo":"2022124578950","startRow":0,"pageSize":0}}

Output needed

amount:300, email:[email protected], mobile:100000012457, accountOwner:Tom Hank

Help this poor dude and leave your btc address I'll send some love thank you

**perfringo** · Oct-08-2022, 09:39 AM

This data is string or dictionary? What have you tried so far?

***snippsat*** · Oct-08-2022, 11:00 AM

The data is probably coming from a Json and has been now encoded to a Python dictionary.
Then work with dictionary no regex need.

data = {
  "_index": "testdataset",
  "_type": "_doc",
  "_id": "11234567891098646",
  "_score": 1,
  "_source": {
    "_class": "net.local.host.ca",
    "orderNo": "16536668566434698646",
    "orderDt": "20220527",
    "source": 0,
    "mchntId": "0000000002",
    "mchntOrderNo": "01a3f2b53d16290f41f",
    "appid": "0000000003",
    "payChannelId": "payid",
    "amount": 300,
    "clientIp": "192.168.0.1",
    "currency": "0",
    "subject": "",
    "body": "",
    "cpChannel": "google_upi",
    "timeExpire": 1653678578000,
    "description": "",
    "created": 1653657857000,
    "timePaid": 1653657876000,
    "bankType": "",
    "paySt": 2,
    "refundSt": 0,
    "refundedAmt": 0,
    "checkSt": 0,
    "fee": 21,
    "chnlFee": 9,
    "settleSt": 1,
    "rutId": "0000000098",
    "bankRspDesc": "",
    "bankTransactionId": "20220527212419602959728091384475",
    "credential": "214721678116",
    "notifyUrl": "https://localhost/test/site",
    "pageNotifyUrl": "https://localhost/test/site",
    "notifyCnt": 0,
    "notifySt": 0,
    "openId": "",
    "extra": "",
    "countryId": "Brazil",
    "areaId": "",
    "regionId": "brazil",
    "cityId": "toto",
    "countyId": "",
    "modified": 1124657876000,
    "channlInfoId": "b0768be2248a4aee94ac747c2ab0000",
    "email": "[email protected]",
    "mobile": "100000012457",
    "accountOwner": "Tom Hank",
    "merchantParam": "game",
    "transTp": 0,
    "payAccount": "",
    "payType": "",
    "bankCode": "",
    "settleBatchNo": "2022124578950",
    "startRow": 0,
    "pageSize": 0
  }
}

Use.

>>> data['_id']
11234567891098646

>>> data["_source"]["amount"]
300
>>> data["_source"]["countryId"]
Brazil

Calli · Oct-09-2022, 02:37 AM

(Oct-08-2022, 11:00 AM)snippsat Wrote: The data is probably coming from a Json and has been now encoded to a Python dictionary.
Then work with dictionary no regex need.

data = {
  "_index": "testdataset",
  "_type": "_doc",
  "_id": "11234567891098646",
  "_score": 1,
  "_source": {
    "_class": "net.local.host.ca",
    "orderNo": "16536668566434698646",
    "orderDt": "20220527",
    "source": 0,
    "mchntId": "0000000002",
    "mchntOrderNo": "01a3f2b53d16290f41f",
    "appid": "0000000003",
    "payChannelId": "payid",
    "amount": 300,
    "clientIp": "192.168.0.1",
    "currency": "0",
    "subject": "",
    "body": "",
    "cpChannel": "google_upi",
    "timeExpire": 1653678578000,
    "description": "",
    "created": 1653657857000,
    "timePaid": 1653657876000,
    "bankType": "",
    "paySt": 2,
    "refundSt": 0,
    "refundedAmt": 0,
    "checkSt": 0,
    "fee": 21,
    "chnlFee": 9,
    "settleSt": 1,
    "rutId": "0000000098",
    "bankRspDesc": "",
    "bankTransactionId": "20220527212419602959728091384475",
    "credential": "214721678116",
    "notifyUrl": "https://localhost/test/site",
    "pageNotifyUrl": "https://localhost/test/site",
    "notifyCnt": 0,
    "notifySt": 0,
    "openId": "",
    "extra": "",
    "countryId": "Brazil",
    "areaId": "",
    "regionId": "brazil",
    "cityId": "toto",
    "countyId": "",
    "modified": 1124657876000,
    "channlInfoId": "b0768be2248a4aee94ac747c2ab0000",
    "email": "[email protected]",
    "mobile": "100000012457",
    "accountOwner": "Tom Hank",
    "merchantParam": "game",
    "transTp": 0,
    "payAccount": "",
    "payType": "",
    "bankCode": "",
    "settleBatchNo": "2022124578950",
    "startRow": 0,
    "pageSize": 0
  }
}

Use.

>>> data['_id']
11234567891098646

>>> data["_source"]["amount"]
300
>>> data["_source"]["countryId"]
Brazil

Yes it's a json file

Calli · Oct-09-2022, 05:19 AM

Donating some bitcoin whoever solve this

rob101 · (This post was last modified: Oct-09-2022, 06:26 AM by rob101.)

To be 'literal', this will do what you've asked for...

print(f"amount: {data['_source']['amount']}, email: {data['_source']['email']}, mobile: {data['_source']['mobile']}, accountOwner: {data['_source']['accountOwner']}")

Output:
amount: 300, email: [email protected], mobile: 100000012457, accountOwner: Tom Hank

... but my guess is that you don't want to be that literal.

So, what's your search criteria?

Calli · Oct-09-2022, 07:22 AM

(Oct-09-2022, 06:25 AM)rob101 Wrote: To be 'literal', this will do what you've asked for...
print(f"amount: {data['_source']['amount']}, email: {data['_source']['email']}, mobile: {data['_source']['mobile']}, accountOwner: {data['_source']['accountOwner']}")
Output:
amount: 300, email: [email protected], mobile: 100000012457, accountOwner: Tom Hank
... but my guess is that you don't want to be that literal.

So, what's your search criteria?

NameError: name 'data' is not defined

f = open('df.json', 'r')

content = f.read(f"amount: {data['_source']['amount']}, email: {data['_source']['email']}, mobile: {data['_source']['mobile']}, accountOwner: {data['_source']['accountOwner']}")

print(content)

rob101 · (This post was last modified: Oct-09-2022, 08:57 AM by rob101.)

Okay, so the jason file has yet to be translated; I'll work on that.

What about:

with open ('df.jason', 'r') as f:
    content = f.read()

temp = content.split(',')

for item in temp:
    if 'amount' in item:
        amount = item.strip()
    elif 'email' in item:
        email = item.strip()
    elif 'mobile' in item:
        mobile = item.strip()
    elif 'accountOwner' in item:
        accountOwner = item.strip()

print(amount,email,mobile,accountOwner)

Output:
"amount":300 "email":"[email protected]" "mobile":"100000012457" "accountOwner":"Tom Hank"

ibreeden · Oct-09-2022, 09:41 AM

(Oct-09-2022, 07:39 AM)rob101 Wrote: Okay, so the jason file has yet to be translated; I'll work on that.

I think there is nothing wrong with the json. You should use the json module for the translating.

(Oct-09-2022, 07:22 AM)Calli Wrote: NameError: name 'data' is not defined

Of course, you should define data.
The whole problem can be solved in 4 lines of code.

import json     # First import the json module.

f = open('df.json', 'r')  # You did that right.
data = json.load(f)
# Now "data" contains the content of the file. According to what you
# showed us, it is a nested dictionary.

# You can now print it like rob101 showed you.
print(f"amount: {data['_source']['amount']}, email: {data['_source']['email']}, mobile: {data['_source']['mobile']}, accountOwner: {data['_source']['accountOwner']}")

Output:
amount: 300, email: [email protected], mobile: 100000012457, accountOwner: Tom Hank

rob101 · Oct-09-2022, 10:08 AM

Oooo... does that mean I get some SATS? Big Grin

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Extract text from PDF	goryee	2	7,500	Jul-08-2024, 06:35 AM Last Post: Pedroski55
	extract only text strip byte array	Pir8Radio	7	7,092	Nov-29-2022, 10:24 PM Last Post: Pir8Radio
	Extract text	rektcol	6	2,834	Jun-28-2022, 08:57 AM Last Post: Gribouillis
	Extract a string between 2 words from a text file	OscarBoots	2	2,767	Nov-02-2021, 08:50 AM Last Post: ibreeden
	Extract text based on postion and pattern	guddu_12	2	2,457	Sep-27-2021, 08:32 PM Last Post: guddu_12
	Extract specific sentences from text file	Bubly	3	5,106	May-31-2021, 06:55 PM Last Post: Larz60+
	extract color text from PDF	Maha	0	2,622	May-31-2021, 04:05 PM Last Post: Maha
	How to extract multiple text from a string?	chatguy	2	3,329	Feb-28-2021, 07:39 AM Last Post: bowlofred
	How to extract a single word from a text file	buttercup	7	7,132	Jul-22-2020, 04:45 AM Last Post: bowlofred
	How to extract specific rows and columns from a text file with Python	Farhan	0	4,158	Mar-25-2020, 09:18 PM Last Post: Farhan

Extract only certain text which are needed

User Panel Messages

Announcements